Learn about the data analysis process, different types of data analysis, and recommended coursework to help you get started in this exciting field.
"It is a capital mistake to theorise before one has data. Insensibly one begins to twist facts to suit theories, instead of theories to suit facts”, Sherlock Holmes proclaims in Sir Arthur Conan Doyle's A Scandal in Bohemia.
This idea lies at the root of data analysis. When we can extract meaning from data, it empowers us to make better decisions. And we’re living in a time when we have more data than ever at our fingertips.
Companies are wising up to the benefits of leveraging data. Data analysis can help a bank to personalise customer interactions, a health care system to predict future health needs, or an entertainment company to create the next big streaming hit.
The World Economic Forum Future of Jobs Report 2020 listed data analysts and scientists as the top emerging job, followed immediately by artificial intelligence (AI), machine learning specialists, and big data specialists [1]. In this article, you'll learn more about the data analysis process, different types of data analysis, and recommended courses to help you get started in this exciting field.
As the data available to companies continues to grow both in amount and complexity, so too does the need for an effective and efficient process by which to harness the value of that data. The data analysis process typically moves through several iterative phases. Let’s take a closer look at each.
Identify the business question you’d like to answer. What problem is the company trying to solve? What do you need to measure, and how will you measure it?
Collect the raw data sets you’ll need to help you answer the identified question. Data collection might come from internal sources, like a company’s client relationship management (CRM) software, or from secondary sources, like government records or social media application programming interfaces (APIs).
Clean the data to prepare it for analysis. This often involves purging duplicate and anomalous data, reconciling inconsistencies, standardising data structure and format, and dealing with white spaces and other syntax errors.
Analyse the data. By manipulating the data using various data analysis techniques and tools, you can find trends, correlations, outliers, and variations that tell a story. During this stage, you might use data mining to discover patterns within databases or data visualisation software to help transform data into an easy-to-understand graphical format.
Interpret the results of your analysis to see how well the data answered your original question. What recommendations can you make based on the data? What are the limitations of your conclusions?
Data can be used to answer questions and support decisions in many different ways. Identifying the best way to analyse your data can help familiarise yourself with the four types of data analysis commonly used in the field.
In this section, we’ll look at these data analysis methods and an example of how each might be applied in the real world.
Descriptive analysis tells us what happened. This type of analysis helps describe or summarise quantitative data by presenting statistics. For example, descriptive statistical analysis could show sales distribution across a group of employees and the average sales figure per employee.
Descriptive analysis answers the question, “What happened?”
If the descriptive analysis determines the “what,” diagnostic analysis determines the “why.” Let’s say a descriptive analysis shows an unusual influx of patients in a hospital. Drilling into the data might reveal that many of these patients shared symptoms of a particular virus. This diagnostic analysis can help you determine that an infectious agent—the “why”—led to the influx of patients.
Diagnostic analysis answers the question, “Why did it happen?”
So far, we’ve looked at types of analysis that examine and draw conclusions about the past. Predictive analytics uses data to form projections about the future. Using predictive analysis, you might notice that a given product has had its best sales during September and October each year, leading you to predict a similar high point during the upcoming year.
Predictive analysis answers the question, “What might happen in the future?”
Prescriptive analysis takes all the insights gathered from the first three types of analysis and uses them to form recommendations for how a company should act. Using our previous example, this type of analysis might suggest a market plan to build on the success of the high sales months and harness new growth opportunities in the slower months.
Prescriptive analysis answers the question, “What should we do about it?”
This last type is where the concept of data-driven decision-making comes into play.
Data-driven decision-making, sometimes abbreviated to DDDM, can be defined as the process of making strategic business decisions based on facts, data, and metrics instead of intuition, emotion, or observation.
Just about any business or organisation can use data analytics to help inform their decisions and boost their performance. Some of the most successful companies across various industries—from Amazon and Netflix to Reliance Industries and HDFC Bank—integrate data into their business plans to improve their overall business performance.
Data analysis makes use of a range of analysis tools and technologies. Some top skills for data analysts include structured query language (SQL), data visualisation, statistical programming languages (like R and Python), machine learning, and spreadsheets.
According to Glassdoor, the average salary for a data analyst in India is ₹5,80,500 2. The salary range is typically between ₹3L and ₹12L.
Data analytics tends to be less maths-intensive than data science. While you probably won’t need to master advanced mathematics, a foundation in basic maths and statistical analysis can help set you up for success.
If you’re interested in a career in the high-growth field of data analytics, you can begin building job-ready skills with the Google Data Analytics Professional Certificate. Prepare yourself for an entry-level job as you learn from Google employees—no experience or degree is required.
World Economic Forum. "The Future of Jobs Report 2020, https://www.weforum.org/reports/the-future-of-jobs-report-2020." Accessed November 12, 2022.
Glassdoor. "Data Analyst Salaries, https://www.glassdoor.co.in/Salaries/india-data-analyst-salary-SRCH_IL.0,5_IN115_KO6,18.htm?clickSource=searchBtn." Accessed November 12, 2022.
Editorial Team
Coursera’s editorial team is comprised of highly experienced professional editors, writers, and fact...
This content has been made available for informational purposes only. Learners are advised to conduct additional research to ensure that courses and other credentials pursued meet their personal, professional, and financial goals.